﻿
use ASIVeste

go

/********************************************************************************************
*****
*****
*********************************************************************************************/


if(OBJECT_ID('getAllSuppliers') is not null)
	DROP PROCEDURE getAllSuppliers
	
go

create procedure getAllSuppliers
as

	select number, name, address
	from Supplier

go

/********************************************************************************************
*****
*****
*********************************************************************************************/



if(OBJECT_ID('addSupplier') is not null)
	DROP PROCEDURE addSupplier
	
go

create procedure addSupplier(@name varchar(100), @address varchar(200))
as

	insert into Supplier(name, address) Values(@name, @address)
	select cast(@@IDENTITY as int)

go

